<%-- 
    Document   : verify_student_profile
    Created on : Apr 12, 2012, 3:09:43 PM
    Author     : project
--%>

<%@page import="java.sql.*"%>
<%@page import="jobportal.Dbconn" %>
<%@include file="header.jsp" %>
<%try{
   Connection con=Dbconn.getConn();
   Statement st=con.createStatement();
   String   sql="SELECT college.clgid,username,photo,name,dob,clgname,email,student.status  FROM student,college where college.clgid='"+session.getAttribute("username")+"' and student.status !='Verified' and college.clgid=student.clgid ";
   ResultSet rs=st.executeQuery(sql);
%>


<table width="100%" border="0" cellpadding="0" cellspacing="0">
    <tr>
        <td align="left" valign="top">

            <span class='messagesred' style="text-align:center">
            </span>

            <table width="100%" border="0" cellspacing="0" >
                <tr>
                    <td width="100%" align="left" valign="top"><span class="mainheading_emp" style="margin-bottom:10px;"> Verify Student Profile</span>
</td>
                </tr>
                <tr>
                    <td height="10" align="left" valign="top" class="normal"></td>
                </tr>
                <tr>
                    <td height="26" align="center" valign="middle" class="normal">
                        <table width="100%" border="0" cellspacing="2"  class="tbl_bdr">
                            <tr class="sde_mnu_hdr_blue" style="color:#000066;font-weight:bold" align="center">
                                <td width="26" height="43"  align="center" valign="middle" class="subjeading" style="background-color: skyblue">#</td>
                                <td width="138" valign="middle" class="subjeading" style="background-color: skyblue">Photo</td>
                              <td width="148" valign="middle" class="subjeading" style="background-color: skyblue"> Name</td>
                              <td width="149" valign="middle" class="subjeading" style="background-color: skyblue">Birthday</td>
                              <td width="129" valign="middle" class="subjeading" style="background-color: skyblue">College</td>
                              <td width="150" valign="middle" class="subjeading" style="background-color: skyblue">Status</td>
                              <td width="251" valign="middle" class="subjeading" style="background-color: skyblue">Action</td>
                          </tr>

                            <%
                                int i=0;
                                while (rs.next()) { i++;
                            %>
          <form name="verstu" action="StudentStatusVerify" method="post">
                            <tr class="greybg" style="font-weight:bold" align="center">
                                <td height="85"  valign="middle" ><%=i%>&nbsp;</td>
                                <td  valign="middle" style="padding-bottom: 17px"><img src="../src/getpic.jsp?id=<%=rs.getString("username")%>&table=student&col=photo&pk_col=username" width="73" height="59" border="0" /></td>
                                <td  valign="middle"><%= rs.getString("name")%></td>
                                <td  valign="middle"><%=rs.getString("dob")%></td>
                                <td  valign="middle"><%=rs.getString("clgname")%></td>
                                <td  valign="middle"><strong><font color='red'><%= rs.getString("status") %></font></strong></td>
                                <td  valign="middle">
                                <a href="myresumes.jsp?username=<%=rs.getString("username")%>" title="View Student Profile"><input id="submit" name="submit" type="submit" value="Profile" class="button2" style="width:80px; height:40px;"></a>
                                <input type="hidden" name="username" value="<%=rs.getString("username")%>">
                               <input id="submit1" name="statusvar" type="submit" value="Verify" class="button2" style="width:80px; height:40px;">
                                
                           </tr>
          </form>
<%}%>

<tr align="center">
                <td width="26" height="30" align="center" valign="middle" class="subjeading" style="background-color: skyblue"></td>
                <td width="138"  valign="middle" class="subjeading" style="background-color: skyblue"></td>
                <td width="148"  valign="middle" class="subjeading" style="background-color: skyblue"></td>
                <td width="149"  valign="middle" class="subjeading" style="background-color: skyblue"></td>
                <td width="129"  valign="middle" class="subjeading" style="background-color: skyblue"></td>
				<td width="150"  valign="middle" class="subjeading" style="background-color: skyblue"></td>
                <td width="251"  valign="middle" class="subjeading" style="background-color: skyblue">&nbsp;</td>
                          </tr>
                  </table></td>
                </tr>
            </table></td>
    </tr>
</table>
<%}catch(Exception e){
out.println("<font color=\"black\">"+e+"</font>");
}%>
<a href="http://apycom.com/"></a>